package cn.zhou.mapper;

import cn.zhou.domain.Role;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * @author zy9524
 * @date 2019/6/9 20:51
 */
public interface RoleMapper {

    @Select("SELECT * FROM roles r , u_r ur WHERE ur.rid = r.id AND ur.uid = #{id}")
    List<Role> findByUid(@Param("id") int id);

}
